<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
	<form action="/queryall.do" method="get"> 	
		<input type="text" name="name" value="${Request.name!}" placeholder="请输入姓名" />
	<select name="classname">
		<option value="">班级查询</option>
	<#list queryClass as queryClasss>
	<#if Request.classname??>
		<#if Request.classname == "${queryClasss.getClassroom()}">
			<option value="${queryClasss.getClassroom()}" selected='selected'>${queryClasss.getClassroom()}</option>
			<#else>
			<option value="${queryClasss.getClassroom()}">${queryClasss.getClassroom()}</option>
		</#if>
		<#else>
		<option value="${queryClasss.getClassroom()}">${queryClasss.getClassroom()}</option>
	</#if>		
	</#list>
		</select>
		<select name="grade">
		<option value="">等级</option>
		<#if Request.grade??>
				<#if Request.grade == '0'>
					<option value="0" selected='selected'>不及格</option>
					<#else>
					<option value="0">不及格</option>
				</#if>
				<#if Request.grade == '1'>
					<option value="1" selected='selected'>及格</option>
					<#else>
					<option value="1">及格</option>
				</#if>
				<#if Request.grade == '2'>
					<option value="2" selected='selected'>优秀</option>
					<#else>
					<option value="2">优秀</option>
				</#if>
				<#if Request.grade == '3'>
					<option value="3" selected='selected'>待审核</option>
					<#else>
					<option value="3">待审核</option>
				</#if>
			<#else>
			<option value="0">不及格</option>
			<option value="1">及格</option>
			<option value="2">优秀</option>
			<option value="3">待审核</option>
		</#if>
		</select>
	<input type="text" name="begin" value="${Request.begins!}" placeholder="请输入开始时间" />
	<input type="text" name="end" value="${Request.ends!}" placeholder="请输入结束时间" />
	<input type="submit" value="查询"/>
	</from>
	<div class="container">
	<div class="row clearfix">
		<div class="col-md-12 column">
			<table class="table" border="1">
				<thead>					
					<tr>
						<th>
							id
						</th>
						<th>
							姓名
						</th>
						<th>
							分数
						</th>
						<th>
							时间
						</th>
						<th>
							班级
						</th>
					</tr>
				</thead>
				<tbody>
				<#list queryAll as querys>
					<tr>
						<td>
							${querys.getId()}	
						</td>
						<td>
							${querys.getName()}	
						</td>
						<td>						
							${querys.getScore()}
						</td>
						<td>
							${querys.getTime()?string["yyyy-MM-dd HH:mm:ss"]}
						</td>
						<td>
							${querys.getClassroom()}
						</td>
					</tr>
				</#list>
				</tbody>
			</table>
		</div>
	</div>
</div>
</body>

</html>